2013-04-10 - 5910.200 - Rel Notes - Contracts - Release 031 #BIReleases2013

Release Notes:

‍5910.200 - SA115 - Corporate Scorecard By Regions


‍Admin Info

Purpose
 Including Contract Information in SA100 - Corporate Scorecard By Regions
Release No
 031
Submitted
 04-10-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name

SA115 - Corporate Scorecard By Regions

BEx Query

ZMP_OOCON_Q001
ZMP_OOCON_Q002

NEC Crystal Reports Standards Check

1. SA115 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA115 NEC CR checklist has been sent to NEC and also attached here for reference:
SA115 NEC CR Standard Check List.xlsx

Excel Files

ProfitCenters.xls
ScorecardDatasource.xls
Retails.xls
Combined.xls
SAPOpenOrders.xls
ScorecardDataByCountry.xls
ScorecardDataByRegion.xls

Main Report Validation


SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 MTD > This Year
 16,660,181
 16,660,180.57
 Pass
2
 MTD > Last Year
 48,082,506
 48,082,506.0882
 Pass
3
 MTD > Budget
 56,220,389
 56,220,388.53
 Pass
4
 MTD > Projected
 43,238,623
 43,238,623.12
 Pass
5
 YTD > This Year
 176,417,116
 176,417,116.286
 Pass
6
 YTD > Last Year
 202,675,220
 202,675,220.12
 Pass
7
 YTD > Budget
 242,520,952
 242,520,952.1
 Pass
8
 YTD > Projected
 202,995,558
 202,995,558.406
 Pass

Regional Sub Report Validation

Test Conducted

NORTH AMERICA


SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 This Year
 12,934,903
 12,934,903
 Pass
2
 Last Year
 34,553,934
 34,553,934
 Pass
3
 Budget
 40,693,960
 40,693,960
 Pass
4
 Projected
 29,674,888
 29,674,888
 Pass
5
 This Year
 137,298,926
 137,298,926
 Pass
6
 Last Year
 162,123,673
 162,123,673
 Pass
7
 Budget
 194,123,673
 194,123,673
 Pass
8
 Projected
 154,038,911
 154,038,911
 Pass

ProductCategory Sub report validation

Test Conducted

HEADWEAR


SNo
 Test Case
 Value in CR
 Value inScorecard Data
 Pass/Fail Criteria
1
 This Year
 14,990,994
 14,990,994
 Pass
2
 Last Year
 40,212,393
 40,212,393
 Pass
3
 Budget
 47,527,938
 47,527,938
 Pass
4
 Projected
 38,541,555
 38,541,555
 Pass
5
 This Year
 147,228,990
 147,228,990
 Pass
6
 Last Year
 166,724,636
 166,724,636
 Pass
7
 Budget
 202,120,789
 202,120,789
 Pass
8
 Projected
 170,779,551
 170,779,551
 Pass

APPAREL >PINK


SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 This Year
 344,249
 344,249
 Pass
2
 Last Year
 0
 0
 Pass
3
 Budget
 3,265,467
 3,265,467
 Pass
4
 Projected
 1,364,232
 1,364,232
 Pass
5
 This Year
 10,851,049
 10,851,049
 Pass
6
 Last Year
 0
 0
 Pass
7
 Budget
 17,502,012
 17,502,012
 Pass
8
 Projected
 11,871,033
 11,871,033
 Pass

NextPeriodRegional Sub report validation

Test Conducted

NORTH AMERICA


SNo
 Test Case
 Value in CR
 Value inScorecard Data
 Pass/Fail Criteria
1
 Last Year
 39,099,159
 39,099,159
 Pass
2
 Budget
 50,192,627
 50,192,627
 Pass
3
 Projected
 25,330,015
 25,330,015
 Pass

NORTH AMERICA > UNITED STATES


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Last Year
 37,103,122
 37,103,122
 Pass
2
 Budget
 48,053,350
 48,053,350
 Pass
3
 Projected
 22,636,987
 22,636,987
 Pass

NextPeriodCategory Sub report validation

Test Conducted

HEADWEAR


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Last Year
 35,498,353
 35,498,353
 Pass
2
 Budget
 40,425,613
 40,425,613
 Pass
3
 Projected
 22,301,208
 22,301,208
 Pass

APPAREL > WOMEN


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Last Year
 930,989
 930,989
 Pass
2
 Budget
 4,346,010
 4,346,010
 Pass
3
 Projected
 1,362,567
 1,362,567
 Pass

Shipped_Open Sub report validation

Test Conducted

NEW ERA > Open Orders


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 35,598,636
 45,604,624
 Pass
2
 Jul
 23,810,047
 23,810,047
 Pass
3
 Aug
 25,955,058
 25,955,058
 Pass
4
 Total
 356,773,641
 356,773,641
 Pass

NEW ERA > Budget



SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 68,445,409
 68,445,409
 Pass
2
 Jul
 64,161,583
 64,161,583
 Pass
3
 Aug
 66,551,857
 66,551,857
 Pass
4
 Total
 727,069,693
 727,069,693
 Pass

NEW ERA > Last Yr Shipped


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 61,528,297
 61,528,297
 Pass
2
 Jul
 54,300,574
 54,300,574
 Pass
3
 Aug
 59,535,855
 59,535,855
 Pass
4
 Total
 641,030,888
 641,030,888
 Pass

NEW ERA > % of Last Yr


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 57.86%
 57.86%
 Pass
2
 Jul
 43.86%
 43.86%
 Pass
3
 Aug
 43.60%
 43.60%
 Pass
4
 Total
 55.66%
 55.66%
 Pass

NEW ERA >% OF Budget


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 52.01%
 52.01%
 Pass
2
 Jul
 37.11%
 37.11%
 Pass
3
 Aug
 39.00%
 39.00%
 Pass
4
 Total
 49.07%
 49.07%
 Pass

NORTH AMERICA

NEW ERA > Open Orders


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 27,104,796
 27,104,796
 Pass
2
 Jul
 16,049,116
 16,049,116
 Pass
3
 Aug
 17,638,292
 17,638,292
 Pass
4
 Total
 262,080,273
 262,080,273
 Pass

NEW ERA > Budget


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 54,937,909
 54,937,909
 Pass
2
 Jul
 52,606,883
 52,606,883
 Pass
3
 Aug
 52,578,598
 52,578,598
 Pass
4
 Total
 568,707,703
 568,707,703
 Pass

NEW ERA > Last Yr Shipped


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 51,342,648
 51,342,648
 Pass
2
 Jul
 44,922,909
 44,922,909
 Pass
3
 Aug
 49,668,769
 49,668,769
 Pass
4
 Total
 512,098,168
 512,098,168
 Pass

NEW ERA > % of Last Yr


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 52.79%
 52.79%
 Pass
2
 Jul
 35.73%
 35.73%
 Pass
3
 Aug
 35.51%
 35.51%
 Pass
4
 Total
 51.18%
 51.18%
 Pass

NEW ERA >% OF Budget


SNo
 Test Case
 Value in CR
 Value in Scorecard Data
 Pass/Fail Criteria
1
 Jun
 49.34%
 49.34%
 Pass
2
 Jul
 30.51%
 30.51%
 Pass
3
 Aug
 33.55%
 33.55%
 Pass
4
 Total
 51.18%
 51.18%
 Pass

Main Report validation

Test Conducted

Parameter : EMEA

HEADWEAR

SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 MTD > This Year
 14,990,994
 14,990,994
 Pass
2
 MTD > Last Year
 40,212,393
 40,212,393
 Pass
3
 MTD > Budget
 47,527,938
 47,527,938
 Pass
4
 YTD > This Year
 147,228,990
 147,228,990
 Pass
5
 YTD > Last Year
 166,724,636
 166,724,636
 Pass
6
 YTD > Budget
 202,120,789
 202,120,789
 Pass

HEADWEAR > EMEA


SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 MTD > This Year
 983,140
 983,140
 Pass
2
 MTD > Last Year
 5,088,705
 5,088,705
 Pass
3
 MTD > Budget
 6,153,803
 6,153,803
 Pass
5
 YTD > This Year
 17,516,838
 17,516,838
 Pass
6
 YTD > Last Year
 17,766,002
 17,766,002
 Pass
7
 YTD > Budget
 20,765,337
 20,765,337
 Pass

HEADWEAR > EMEA > LIFESTYLE


SNo
 Test Case
 Value in CR
 Value from Sheet/Scorecard Data Source
 Pass/Fail Criteria
1
 MTD > This Year
 758,477
 758,477
 Pass
2
 MTD > Last Year
 3,392,716
 3,392,716
 Pass
3
 MTD > Budget
 6,153,803
 6,153,803
 Pass
4
 YTD > This Year
 11,361,274
 11,361,274
 Pass
5
 YTD > Last Year
 11,628,296
 11,628,296
 Pass
6
 YTD > Budget
 20,765,337
 20,765,337
 Pass

Retails Sub Report validation

Test Conducted

Parameter : EMEA

NEW ERA > Day


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail Data Source
 Pass/Fail Criteria
1
 Units
 600
 600
 Pass
2
 TY
 15,602
 15,602
 Pass
3
 LY
 19,701
 19,701
 Pass
4
 % to LY
 -21%
 -21%
 Pass

NEW ERA > Month-To-Date


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail Data Source
 Pass/Fail Criteria
1
 Units
 11,776
 11,776
 Pass
2
 TY
 381,754
 381,754
 Pass
3
 LY
 361,541
 361,541
 Pass
4
 % to LY
 6%
 6%
 Pass

NEW ERA > Year-To-Date


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail source
 Pass/Fail Criteria
1
 Units
 32,492
 32,492
 Pass
2
 TY
 1.079.992
 1.079.992
 Pass
3
 LY
 922,209
 922,209
 Pass
4
 % to LY
 17%
 17%
 Pass

EMEA > Day


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail Data Source
 Pass/Fail Criteria
1
 Units
 600
 600
 Pass
2
 TY
 15,602
 15,602
 Pass
3
 LY
 13,357
 13,357
 Pass
4
 % to LY
 15
 15%
 Pass

EMEA > Month-To-Date


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail Data Source
 Pass/Fail Criteria
1
 Units
 9,878
 9,878
 Pass
2
 TY
 266,742
 266,742
 Pass
3
 LY
 219,139
 219,139
 Pass
4
 % to LY
 22%
 22%
 Pass

EMEA > Year-To-Date


SNo
 Test Case
 Value in CR
 Value from Sheet/Retail source
 Pass/Fail Criteria
1
 Units
 25,510
 25,510
 Pass
2
 TY
 629,638
 629,638
 Pass
3
 LY
 564,754
 564,754
 Pass
4
 % to LY
 11%
 11%
 Pass

OpenOrderSubReport validation

Test Conducted

Parameter : EMERGING MARKET


SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 WEEK ENDING Apr 07 > Total Open Value
 484,689
 484,689
 Pass
2
 WEEK ENDING Apr 07 > Total Open Quantity
 30,554
 30,554
 Pass
3
 WEEK ENDING Apr 14 > Total Open Value
 430,245
 430,245
 Pass
4
 WEEK ENDING Apr 14 > Total Open Quantity
 29,082
 29,082
 Pass
5
 WEEK ENDING Apr 21 > Total Open Value
 595,221
 595,221.30
 Pass
6
 WEEK ENDING Apr 21 > Total Open Quantity
 37,936
 37,936
 Pass
7
 WEEK ENDING Apr 28 > Total Open Value
 253,409
 253,409
 Pass
8
 WEEK ENDING Apr 28 > Total Open Quantity
 25,182
 25,182
 Pass
15
 Total Open Value
 1,763,565
 1,763,565
 Pass
16
 Total Open Quantity
 122,754
 122,754
 Pass

OpenOrderSub2 Report Validation

Test Conducted

Parameter : JAPAN

2013 > Apr > Total


SNo
 Test Case
 Value in CR
 Value from Sheet/SAPOpenOrders source
 Pass/Fail Criteria
1
 Total
 1,490,647
 1,490,647
 Pass
2
 NA
 159,543
 159,543
 Pass
3
 APP
 48,311
 48,311
 Pass
4
 HW
 1,282,793
 1,282,793
 Pass

Hot Market Open Orders by Collection and Team

Test Conducted


SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 NBA WHITEOUT > No. of Orders
 8
 8
 Pass
2
 NBA WHITEOUT > Confirmed Qty
 1,092
 1,092
 Pass
3
 NBA WHITEOUT > Total Open Value
 11,466
 11,466.00
 Pass
4
 SB CHASE > BALTIMORE RAVENS > No. of Orders
 17
 17
 Pass
5
 SB CHASE > BALTIMORE RAVENS > Confirmed Qty
 1,126
 1,126
 Pass
6
 SB CHASE > BALTIMORE RAVENS >Total Open Value
 16,192
 16,192.08
 Pass
7
 Hot Market Grand Total > No. of Orders
 32
 32
 Pass
8
 Hot Market Grand Total > Confirmed Qty
 2,464
 2,464
 Pass
9
 Hot Market Grand Total > Total Open Value
 30,662
 30,661.76
 Pass

Top 15 Countries Report Validation

Test Conducted

Parameter : JAPAN

NEW ERA


SNo
 Test Case
 Value in CR
 Value from Sheet/ScorcardByDataCountry source
 Pass/Fail Criteria
1
 MTD > This Year
 16,278,459
 16,278,459
 Pass
2
 MTD > Last Year
 47,720,970
 47,720,970
 Pass
3
 YTD > This Year
 175,337,139
 175,337,139
 Pass
4
 YTD > Last Year
 201,753,026
 201,753,026
 Pass

NEW ERA > JAPAN


SNo
 Test Case
 Value in CR
 Value from Sheet/ ScorecardDataByCountry source
 Pass/Fail Criteria
1
 MTD > This Year
 185,299
 185,299
 Pass
2
 MTD > Last Year
 820,412
 820,412
 Pass
3
 YTD > This Year
 2,326,881
 2,326,881
 Pass
4
 YTD > Last Year
 3,462,838
 3,462,838
 Pass

Customer Group 9 Regions Report Validation

Test Conducted

Parameter : JAPAN

NEW ERA


SNo
 Test Case
 Value in CR
 Value from Sheet/ScorcardByCountry source
 Pass/Fail Criteria
1
 MTD > This Year
 16,278,459
 16,278,459
 Pass
2
 MTD > Last Year
 47,720,970
 47,720,970
 Pass
3
 YTD > This Year
 175,337,139
 175,337,139
 Pass
4
 YTD > Last Year
 201,753,026
 201,753,026
 Pass

NEW ERA > JAPAN


SNo
 Test Case
 Value in CR
 Value from Sheet/ ScorecardDataByCountry source
 Pass/Fail Criteria
1
 MTD > This Year
 1,314,153
 1,314,153
 Pass
2
 MTD > Last Year
 3,354,484
 3,354,484
 Pass
3
 YTD > This Year
 6,812,824
 6,812,824
 Pass
4
 YTD > Last Year
 9,539,960
 9,539,960
 Pass

Customer Group 9 Regions Report Validation

Test Conducted

NEW ERA


SNo
 Test Case
 Value in CR
 Value from Sheet/ScorcardByRegion source
 Pass/Fail Criteria
1
 MTD > This Year
 16,278,459
 16,278,459
 Pass
2
 MTD > Last Year
 47,720,970
 47,720,970
 Pass
3
 YTD > This Year
 175,337,139
 175,337,139
 Pass
4
 YTD > Last Year
 201,753,026
 201,753,026
 Pass

NEW ERA > JAPAN


SNo
 Test Case
 Value in CR
 Value from Sheet/ ScorecardDataByRegion source
 Pass/Fail Criteria
1
 MTD > This Year
 1,314,153
 1,314,153
 Pass
2
 MTD > Last Year
 3,354,484
 3,354,484
 Pass
3
 YTD > This Year
 6,812,824
 6,812,824
 Pass
4
 YTD > Last Year
 9,539,960
 9,539,960
 Pass

Reference Document(Specification)

2013-03-15 - 5910.200 - Spec - Contract Report